Reasoning behind choices :
The file project contains all the tables used in this project and based of the E/A
diagram.
Our main table is Student : we chose as a primary key to this table the
attribute StudentID, as explained in the description given by the professor,
Mister Meunier wants to follow the students during their schooling, this is why
we created the table Student with their name, the sex, the date of birth and the
grade as attributes.
Also he want to follow them in their professional life through the alumni
association, so we create a table Alumni with the name of their company.
We needed a table Course to allow us to see the courses of students but also
professors with their salaries directly related to the AdministrationStaff, with StaffID,
the primary Key.
The teacher table allows us to track the availability of teachers and thus allow
them to carry out their course.
We have also created a table with tuition fees for students with as primary key,
TuitionFeesId
M. Meunier wishes to know the need to open school canteens on his
campuses in London, Pekin and New York. He is therefore interested in the
attendance rate of the canteen of the Ivry and Marseille campuses to validate
an opening on another campus.
It is for this reason that we decided to create a Canteen and canteen Attendance
table in order to have the number of students each month in a canteen, this one is
directly connected to the campus with as primary keys Attendance ID.